<?php
$loc ="login";
require_once('mysql_connect.php');
include('top.php');
$query = "CREATE TABLE movie(id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, type INT(10), name TEXT, genre INT(10), rating TEXT, description LONGTEXT, runningtime TEXT, year TEXT, PRIMARY KEY(id))";
$result = @mysql_query($query);
$query = "CREATE TABLE users(id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, type INT(10), email TEXT, phone INT(10), password TEXT, admin INT(10), PRIMARY KEY(id))";
$result = @mysql_query($query);
$query = "CREATE TABLE checkout(id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, movieid INT(10), date DATE, usersid INT(10), PRIMARY KEY(id))";
$result = @mysql_query($query);
$query = "CREATE TABLE picture(id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, movieid INT(10), ext TEXT, PRIMARY KEY(id))";
$result = @mysql_query($query);
$query = "CREATE TABLE actor(id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, name TEXT, PRIMARY KEY(id))";
$result = @mysql_query($query);
$query = "CREATE TABLE type(id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, name TEXT, PRIMARY KEY(id))";
$result = @mysql_query($query);
$query = "CREATE TABLE genre(id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, name TEXT, PRIMARY KEY(id))";
$result = @mysql_query($query);
$query = "CREATE TABLE actormovie(id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, actorid INT(10), movieid  INT(10), PRIMARY KEY(id))";
$result = @mysql_query($query);
$query = "CREATE TABLE system(id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, accounts INT(10), PRIMARY KEY(id))";
$result = @mysql_query($query);
$query = "INSERT INTO system(accounts) VALUES(1)";
$result = @mysql_query($query);
?>
<FONT FACE="Verdana" size=-1>Population Complete</FONT>
<?php
include('bot.php');
unlink('setup.php');
?>